| FaApproveDisbCriteria |
| Logical Entity Name | FaApproveDisbCriteria |
| Default Table Name | FaApproveDisbCriteria |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| FaApproveDisbCriteria Columns |
| FaApproveDisbCriteria Primary and Unique Keys |
| Key Name | Key Type | Keys |
| FaApproveDisbCriteria_Code_U_N_IDX | Index | Code |
| FaApproveDisbCriteria_FaApproveDisbCriteriaID_U_C_IDX | PrimaryKey | FaApproveDisbCriteriaID |
| FaApproveDisbCriteria Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdAttStat | Non-Identifying | Zero or One to Zero or More | FK_FaApproveDisbCriteria_MinAdAttStatId_AdAttStat_AdAttStatId | MinAdAttStatId | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaApproveDisbCriteria_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaApprovDisbSchoolStatus | Identifying | One To Zero or More | FK_FaApprovDisbSchoolStatus_FaApproveDisbCriteriaID_FaApproveDisbCriteria_FaApproveDisbCriteriaID | NO | YES | |||
| FaApproveDisbCriteriaSubsequent | Non-Identifying | One To Zero or More | FK_FaApproveDisbCriteriaSubsequent_FaApproveDisbCriteriaID_FaApproveDisbCriteria_aFaApproveDisbCriteriaID | NO | YES | |||
| FaApproveDisbDocTypes | Identifying | One To Zero or More | FK_FaApproveDisbDocTypes_FaApproveDisbCriteriaID | NO | YES | |||
| FaDisbCriteriaCampusFundSource | Non-Identifying | One To Zero or More | FK_FaDisbCriteriaCampusFundSource_FaApproveDisbCriteriaID_FaApproveDisbCriteria_FaApproveDisbCriteriaID | NO | YES |
| FaApproveDisbCriteria Check Constraints |
| Check Constraint Name | CheckConstraint |
| Chk_FaApproveDisbCriteria_MinCumulativeGPAFlag_MinCumulativeGPA | ([MinCumulativeGPAFlag] = 1 and [MinCumulativeGPA] > 0 or [MinCumulativeGPAFlag] = 0 and [MinCumulativeGPA] = 0) |
| Chk_FaApproveDisbCriteria_MinNumAvgFlag_MinNumAvg | ([MinNumAvgFlag] = 1 and [MinNumAvg] > 0 or [MinNumAvgFlag] = 0 and [MinNumAvg] = 0) |
| Chk_FaApproveDisbCriteria_MinHoursAttFlag_MinHoursAtt | ([MinHoursAttFlag] = 1 and [MinHoursAtt] > 0 or [MinHoursAttFlag] = 0 and [MinHoursAtt] = 0) |
| Chk_FaApproveDisbCriteria_MinPctAttFlag_MinPctAtt | ([MinPctAttFlag] = 1 and [MinPctAtt] > 0 or [MinPctAttFlag] = 0 and [MinPctAtt] = 0) |
| Chk_MinHoursCreditsSchedFlag_MinHoursSched_MinCreditsSched | ([MinHoursCreditsSchedFlag] = 1 and ([MinHoursSched] > 0 or [MinCreditsSched] > 0) or [MinHoursCreditsSchedFlag] = 0 and ([MinHoursSched] = 0 and [MinCreditsSched] = 0)) |
| Chk_MinHoursCreditsCompFlag_MinHoursSched_MinCreditsComp | ([MinHoursCreditsCompFlag] = 1 and ([MinHoursComp] > 0 or [MinCreditsComp] > 0) or [MinHoursCreditsCompFlag] = 0 and ([MinHoursComp] = 0 and [MinCreditsComp] = 0)) |
| Chk_FaApproveDisbCriteria_MaxDaysFromLoanEndDateFlag_MaxDaysFromLoanEndDate | ([MaxDaysFromLoanEndDateFlag] = 1 and [MaxDaysFromLoanEndDate] >= 0 or [MaxDaysFromLoanEndDateFlag] = 0 and [MaxDaysFromLoanEndDate] = 0) |
| Chk_FaApproveDisbCriteria_MaxDiffDisbAmtFlag_MaxDiffDisbAmt | ([MaxDiffDisbAmtFlag] = 1 and [MaxDiffDisbAmt] >= 0 or [MaxDiffDisbAmtFlag] = 0 and [MaxDiffDisbAmt] = 0) |
| Chk_FaApproveDisbCriteria_MaxDaysAfterStudLDAFlag_MaxDaysAfterStudLDA | ([MaxDaysAfterStudLDAFlag] = 1 and [MaxDaysAfterStudLDA] >= 0 or [MaxDaysAfterStudLDAFlag] = 0 and [MaxDaysAfterStudLDAFlag] = 0) |
| FaApproveDisbCriteria Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group |
| FaApproveDisbCriteria Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.DisbursementApprovalRule |
NO | |||
| Physical (Microsoft SQL Server) dbo.FaApproveDisbCriteria |
NO |
| FaApproveDisbCriteria Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Financial Aid |
| FaApproveDisbCriteria Data Movement Rules |
| Name | Type | Rule Text/Value |